package com.isky.visual.constant;

/**
 * @version v1.0
 * @ProjectName visual_parent
 * @ClassName TableSql
 * @Description TODO 通用的sql 语句
 * @Author wudl
 * @Date DATE{TIME}
 */

public class TableSql {

//    public static final String  SHOW_COLUMN_SQL = "select column_name from information_schema.COLUMNS where table_name=";
    /**
     * 查询
     */
    public static final String  SHOW_COLUMN_MySQL = "SELECT COLUMN_NAME AS name,if( COLUMN_COMMENT is null or COLUMN_COMMENT='', COLUMN_NAME, COLUMN_COMMENT) AS namecn FROM information_schema.COLUMNS WHERE TABLE_NAME=";
    public static final String  SHOW_TABLE_MySQL = "SELECT TABLE_NAME,TABLE_COMMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA=";

}
